UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aJ6cM31DIYkLJD9dsDnRbIAqyheoAGgDwhFK6oNaHvU='
WHERE
key_id = '264704d35184617b996b2611737e1bc2f6256e140b3ebabaa2aac3d38eca81d0'
AND (
token = 'aJ6cM31DIYkLJD9dsDnRbIAqyheoAGgDwhFK6oNaHvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)