UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nPAq9kQoMoWytSZ0b8gd+Obvzrv8mJVcBy9xqeZGlJ0='
WHERE
key_id = 'dd6f1be38549295a3b97a7a112292e86f05b85f9adba39f91aedb84239558623'
AND (
token = 'nPAq9kQoMoWytSZ0b8gd+Obvzrv8mJVcBy9xqeZGlJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)