UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jrefAW0CWoqtcrX/gvyNeRb5znQ2CX1ZECBADgWchm0='
WHERE
key_id = '8c0c28c8176a612c062921a419b2ae0cf64731133c53269b490ba4dd0f8b973b'
AND (
token = 'jrefAW0CWoqtcrX/gvyNeRb5znQ2CX1ZECBADgWchm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)