UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xXI9YHeJcymRTUjuKhUL+MLek828b/GImFTwnKzsmKA='
WHERE
key_id = 'e2f68c85c9d154e26f41fce3b90cbf2dbd0876acd49e3e14fba559d17cfe4c19'
AND (
token = 'xXI9YHeJcymRTUjuKhUL+MLek828b/GImFTwnKzsmKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)