UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9f1W7J2b0llBjNvJzWQTyN6gpduojlvKmoCktDwbLuI='
WHERE
key_id = '5988b0c6d11ecee564e0342f831a15cc78df8104a70d314f9c63b29c8fec2d35'
AND (
token = '9f1W7J2b0llBjNvJzWQTyN6gpduojlvKmoCktDwbLuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)