UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zldCX8qHEzdMJX0bblPhn0KKIs5IAS+FrEA+eP++HA0='
WHERE
key_id = '49b2dd50583025431516587ab01da33a7d0800f50224abbb1115c3f8485d4ea8'
AND (
token = 'zldCX8qHEzdMJX0bblPhn0KKIs5IAS+FrEA+eP++HA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)