UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oIu3/sXwKfwOANtUfIIM+KWslkntPPk+fL+sbaEgA8I='
WHERE
key_id = '3bb73d766e7c0f44a68218fba94b98427631b4155226ad336c6016ca4e5a904a'
AND (
token = 'oIu3/sXwKfwOANtUfIIM+KWslkntPPk+fL+sbaEgA8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)