UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N57ooqwlinCmNpwkQk846mzloDjQW2xeHHCNdx2wKfc='
WHERE
key_id = '2424c6397df7bd27400296ffdca158d385cf27e048fd8f3fa85310df1aa2aa5b'
AND (
token = 'N57ooqwlinCmNpwkQk846mzloDjQW2xeHHCNdx2wKfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)