UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XK+DTlG0gyyUsP8WNgheMr7e4634lKIgmxejxzhVb/M='
WHERE
key_id = 'a1e53aa34ae10f4c36a36fc39a60a10e3d7a0ca4fa69a16dd9d6078891cf33fe'
AND (
token = 'XK+DTlG0gyyUsP8WNgheMr7e4634lKIgmxejxzhVb/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)