UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zAkPvj2SIUhuhOeyqaok9BedY7v/B1RcZBkgK6tQVD0='
WHERE
key_id = '219564a2e118d2114811375d44486d5db08ab7425408612eb6d2d8c1c0bda40a'
AND (
token = 'zAkPvj2SIUhuhOeyqaok9BedY7v/B1RcZBkgK6tQVD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)