UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lNC13nG6cklwiD/1WlIu1kcVvXTS6n5eVPGI5ASxceI='
WHERE
key_id = '714497ab979b3a5caffc30d8d0d3675be0ee2f9c7576e1bf115ef9c0c03a579a'
AND (
token = 'lNC13nG6cklwiD/1WlIu1kcVvXTS6n5eVPGI5ASxceI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)