UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6b6Um7JuLeOzS6xcscxmwOMVEhgfxHGjt1X3yWjvOo4='
WHERE
key_id = 'cda10fd423e72f9d01bbe32a58012a6fe17e75a6e78907d89f6753438d7c44ce'
AND (
token = '6b6Um7JuLeOzS6xcscxmwOMVEhgfxHGjt1X3yWjvOo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)