UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0J4UFrX3cx7Ec6rotEdOxD/OmeJsu5Dv9fy5PzciBgY='
WHERE
key_id = 'a9e67330d0b41d1a97bbc1de6cfac6856a64cd69b65b052dd1c3dc831ca60795'
AND (
token = '0J4UFrX3cx7Ec6rotEdOxD/OmeJsu5Dv9fy5PzciBgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)