UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XqTgMV41jmvEs9yxeogK81tIdylOdQcQPIWESj5aUc='
WHERE
key_id = 'd3be3e87c2650e994af9431dc72b948264af221244ccc715588494fb11f95762'
AND (
token = '9XqTgMV41jmvEs9yxeogK81tIdylOdQcQPIWESj5aUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)