UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '84/mcNRLf0jN7koLSCpbcpWhRxm3UAs7pfm1T9I4pOk='
WHERE
key_id = 'b400d9cebe1245922e89cccb1bb6faa0c14e29c2f31e5e5f09babafc8eb3891f'
AND (
token = '84/mcNRLf0jN7koLSCpbcpWhRxm3UAs7pfm1T9I4pOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)