UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jI3c4nFLmPTOidqYPBaVBudbSb18gskipW70jCygBPQ='
WHERE
key_id = 'c1111017d18c1de3e71fd6d23bcc9a9d8582d7979e4d0ef3620ae0c7ecd65157'
AND (
token = 'jI3c4nFLmPTOidqYPBaVBudbSb18gskipW70jCygBPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)