UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BpvJvEIO2SGcTachGC6LUoef9+ZHE/95PWjg/leN/wU='
WHERE
key_id = 'cb2df1de36dc5ebf74103669ec70d0e346d9f3e80454ac1149400b644787d3d9'
AND (
token = 'BpvJvEIO2SGcTachGC6LUoef9+ZHE/95PWjg/leN/wU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)