UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SRtH4nwlYmGgZJRuVlEBwaJb7F3GZYxOu0lHWdA6KoY='
WHERE
key_id = '87932d8f3910f0077011c225dd49b3ab8cc4e484ce7548d1fe21afc58827b13c'
AND (
token = 'SRtH4nwlYmGgZJRuVlEBwaJb7F3GZYxOu0lHWdA6KoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)