UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5VPmZ3IikUZEVNHygVnp+40lwRsjQBxXNt5qae5PC3A='
WHERE
key_id = '3a93d61bb158b14ecd31ff31ba5fa7ea402f690385f0209210c77dc7fc309572'
AND (
token = '5VPmZ3IikUZEVNHygVnp+40lwRsjQBxXNt5qae5PC3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)