UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zhVm9a5nOc01ucEF1rNGCuKvXpRLc4ED2V7/GIQIiiM='
WHERE
key_id = '0befd57606f5b9af91a862a6b26dccd980cc943f1c3731324cfd7042e93f8cce'
AND (
token = 'zhVm9a5nOc01ucEF1rNGCuKvXpRLc4ED2V7/GIQIiiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)