UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PVJYce4IaHRgVqep3EPESVxd98pGNG8KJPDMtKbjRAA='
WHERE
key_id = '47d51cf47dd3fb6b1fdeb3648e717eb2c14842421ea4e23d0cb680f80d9343e5'
AND (
token = 'PVJYce4IaHRgVqep3EPESVxd98pGNG8KJPDMtKbjRAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)