UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LwDBNys8yklPBIP3QonIW/166bFfX/cGwSkRL4wIGUg='
WHERE
key_id = 'eed33ba3b1a4effa4ee336d1d0c4acd04d892d8e5d1722c73a5508d9133129a5'
AND (
token = 'LwDBNys8yklPBIP3QonIW/166bFfX/cGwSkRL4wIGUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)