UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '20T1ec8BpqhDLYtFGtypZikogpCKQDMWtFLuJVDAlHM='
WHERE
key_id = '078bee6f93d33181d512d8190f96d1f762867123cb862d3146fe625fb780ea76'
AND (
token = '20T1ec8BpqhDLYtFGtypZikogpCKQDMWtFLuJVDAlHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)