UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XoNrcZspeFMbgKPqS3P5B191fIy1ADEI1+ahuKJc3zU='
WHERE
key_id = '475571015b91afa7ce9905e8e80a3cb6dadce49e88b0408867468032e3cffa11'
AND (
token = 'XoNrcZspeFMbgKPqS3P5B191fIy1ADEI1+ahuKJc3zU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)