UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lr6TDG3jnNTWV32tDMIi7yozxu1tRYUXYR+a09hKUws='
WHERE
key_id = '0c3e97ff971cea90b77026bfc8bcf736670507da666f5dd35e8131a4b60109c6'
AND (
token = 'Lr6TDG3jnNTWV32tDMIi7yozxu1tRYUXYR+a09hKUws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)