UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CaSMyI+eDYFr2ydCwo5K/GTtGUHsb2rW6BNnn6wxvTc='
WHERE
key_id = '97e197bf36f15e7b20725af48d08548213c818911f19f01cdccdcb03f1fcb442'
AND (
token = 'CaSMyI+eDYFr2ydCwo5K/GTtGUHsb2rW6BNnn6wxvTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)