UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LpLGBzpo7mj50C6T/TYfaWy5JyLGbVgU5H3DgIi76J8='
WHERE
key_id = 'bc4f3019b7f6fc2bf891754db53871569fb1d75e8c7e7976b532c909cb2b921e'
AND (
token = 'LpLGBzpo7mj50C6T/TYfaWy5JyLGbVgU5H3DgIi76J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)