UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tlojZCI8oXSw9k5KM6yjyYPE5QVrgyQsJl8PXUqXaQs='
WHERE
key_id = 'b864d03e2e7d973abde6f1bfc0a3798d19cbf33cabf187912c3acc6980ba0138'
AND (
token = 'tlojZCI8oXSw9k5KM6yjyYPE5QVrgyQsJl8PXUqXaQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)