UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vjZ+S7Vmc4o6G0ht3DXhlIr1Pw3EXFeiHx/J9J6WTzw='
WHERE
key_id = 'd7ecf550ecb95f16494e8b77da76302e51820811abdadba51a7621974269c9ab'
AND (
token = 'vjZ+S7Vmc4o6G0ht3DXhlIr1Pw3EXFeiHx/J9J6WTzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)