UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YcEqXZr1K0xFjnhK8K/13fGDvs4mKhn5K4fpfOG7Ghw='
WHERE
key_id = '3380266cfa9df2bb48aa169aaa02db946151d8915891f013d0237a52e47f204a'
AND (
token = 'YcEqXZr1K0xFjnhK8K/13fGDvs4mKhn5K4fpfOG7Ghw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)