UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4cAhcxSKxIuSM/e7e2JBXIYmn3O1PF/9Bm3n0ics99E='
WHERE
key_id = '00c78787e6927e39ba17052622f9edfc4f86af8475ffde0643a64a6f7140e9ef'
AND (
token = '4cAhcxSKxIuSM/e7e2JBXIYmn3O1PF/9Bm3n0ics99E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)