UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LKQtxneN0xEuhwYXkABe/SrN9J1GNV9LDsJjJyvsagI='
WHERE
key_id = '271742d524cdf8f5794aaab3d1c9e7afd4498e9676f59c9b6c2c9f578b4639b8'
AND (
token = 'LKQtxneN0xEuhwYXkABe/SrN9J1GNV9LDsJjJyvsagI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)