UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7RAic6Xi+VXTTTOu4VTvIF2ouEHHGKK+vJVEnHNjTV8='
WHERE
key_id = '7d928a816c5fe68348e387d6cb7eb25a1c174e5aba5aa63c01bd93fdce4fdddc'
AND (
token = '7RAic6Xi+VXTTTOu4VTvIF2ouEHHGKK+vJVEnHNjTV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)