UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhjY6pAkWe18chskNM4LZVA1YjJep5IZCR8dK8eyA/I='
WHERE
key_id = '3fb1cb4a5acc78e206a1cc1b1772e11ff2f8173c673eb13a24f79a68a57374a9'
AND (
token = 'BhjY6pAkWe18chskNM4LZVA1YjJep5IZCR8dK8eyA/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)