UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KS4L1hojudJ+5i5JvgrGfCeK/ZhjpLOnonxEsXl+wnM='
WHERE
key_id = '505768225a4598c8dde04da62d45ec75bb74ff7c2af920211eca14f69b9b0b60'
AND (
token = 'KS4L1hojudJ+5i5JvgrGfCeK/ZhjpLOnonxEsXl+wnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)