UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BfzBqsLiHfE4HpvVeSDIYzuGrztPbqA6z7L7fbUuqE='
WHERE
key_id = '1ca3f0b32ed9cd4058f06bce75637c112d476bb18ac2433da904038e697c0ad9'
AND (
token = '0BfzBqsLiHfE4HpvVeSDIYzuGrztPbqA6z7L7fbUuqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)