UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3ZnUkjr3WsoJcUXyXHurknQ06ONiRQpFUaJlgznEpYM='
WHERE
key_id = 'b4e83e99afb4a983eaa921518a52bede5642fcad9b6b72ed4188dbdbc4e02bf6'
AND (
token = '3ZnUkjr3WsoJcUXyXHurknQ06ONiRQpFUaJlgznEpYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)