UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XTrJPX0ji0h2bsRZkvzPJV+sz63BwHuAbcuahLSrWpo='
WHERE
key_id = 'b6e79b5ccc350eee085edd5a286296cbf165a4dd6a24628bd921ed48d47cea1f'
AND (
token = 'XTrJPX0ji0h2bsRZkvzPJV+sz63BwHuAbcuahLSrWpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)