UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tVgGe1l3pvuyX6gFkc57M3jsguP37B71crHI4avDE60='
WHERE
key_id = '996269a2313844d7b1881a23864dbd00e75874d44ffaab69d81bae99302d4ac2'
AND (
token = 'tVgGe1l3pvuyX6gFkc57M3jsguP37B71crHI4avDE60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)