UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o0UGTbuV6sbWbfh7sJ9HAhyHdjxh1u5hw9qin0MkfQw='
WHERE
key_id = '7ef470bd130a790c3f72d2955f31920940cd4f111fdc908dadb2271b70920b53'
AND (
token = 'o0UGTbuV6sbWbfh7sJ9HAhyHdjxh1u5hw9qin0MkfQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)